/*
	Drops all procedures.
*/

SET ANSI_NULLS ON 
GO

IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spExpertiseLevelCreate' ) )
   DROP PROCEDURE spExpertiseLevelCreate
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spExpertiseLevelUpdate' ) )
   DROP PROCEDURE spExpertiseLevelUpdate
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spExpertiseLevelGet' ) )
   DROP PROCEDURE spExpertiseLevelGet
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spExpertiseLevelList' ) )
   DROP PROCEDURE spExpertiseLevelList
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spTechnologyCreate' ) )
   DROP PROCEDURE spTechnologyCreate
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spTechnologyUpdate' ) )
   DROP PROCEDURE spTechnologyUpdate
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spTechnologyGet' ) )
   DROP PROCEDURE spTechnologyGet
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spTechnologyList' ) )
   DROP PROCEDURE spTechnologyList
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalStatusCreate' ) )
   DROP PROCEDURE spGoalStatusCreate
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalStatusUpdate' ) )
   DROP PROCEDURE spGoalStatusUpdate
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalStatusGet' ) )
   DROP PROCEDURE spGoalStatusGet
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalStatusList' ) )
   DROP PROCEDURE spGoalStatusList
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalCreate' ) )
   DROP PROCEDURE spGoalCreate
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalUpdate' ) )
   DROP PROCEDURE spGoalUpdate
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalGet' ) )
   DROP PROCEDURE spGoalGet
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalList' ) )
   DROP PROCEDURE spGoalList
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalListByStatus' ) )
   DROP PROCEDURE spGoalListByStatus
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalRequiredExpertiseCreate' ) )
   DROP PROCEDURE spGoalRequiredExpertiseCreate
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalRequiredExpertiseUpdate' ) )
   DROP PROCEDURE spGoalRequiredExpertiseUpdate
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalRequiredExpertiseGet' ) )
   DROP PROCEDURE spGoalRequiredExpertiseGet
GO
		
IF ( EXISTS( SELECT id FROM sysobjects WHERE xtype = 'P' AND name = 'spGoalRequiredExpertiseList' ) )
   DROP PROCEDURE spGoalRequiredExpertiseList
GO
		


SET ANSI_NULLS OFF
GO   
	